Oracle

Configuration Adaptations

The SQL scripts required for the Orchestra installation can be found on the Orchestra CD in the directory: .../Database/Oracle_Other/system.

1. Start your utility program to access your Oracle database.

2. Log in as user SYSTEM (sysdba).

3. Open the script V00_sys_tablespace.sql and adjust the paths to match your local system.

4. Run the script.

5. Open the script V01_sys_create_schema.sql.

   warning

   The password of the ORCHESTRA database user should be changed for security reasons!

6. Run the script.

7. Disconnect and log in as ORCHESTRA (default password Orchestra).

8. Open the SQL script V02_install_orchestra_all.sql. This script will create all tables for the Orchestra schema, run all other scripts, and create a log file named Install_Orchestra_Oracle.log.

   warning

   The user created in step 5 has been assigned the default profile, which implies a limited password lifetime in Oracle Versions 10 and 11. This is generally not desired for the Orchestra runtime user. To change the default behavior, run the following statements as an admin user:

   CREATE PROFILE ORC_PROFILE LIMIT
   FAILED_LOGIN_ATTEMPTS UNLIMITED
   PASSWORD_LIFE_TIME UNLIMITED;
   
   ALTER USER <Orchestra-Runtime-User>
   PROFILE ORC_PROFILE;